DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` tinyint(4) NOT NULL auto_increment,
  `category` varchar(255) NOT NULL default '',
  `desc` text,
  `sortOrder` int(4) default '0',
  `footer` text,
  PRIMARY KEY  (`id`),
  KEY `sortOrder` (`sortOrder`),
  FULLTEXT KEY `category` (`category`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `item` tinyint(3) NOT NULL auto_increment,
  `name` tinytext,
  `desc` text,
  `price` double default NULL,
  `photo` tinytext,
  `link` tinytext,
  `category` tinyint(3) default '0',
  `extraTextBlock` text,
  `indent` tinyint(1) default '0',
  `feature` tinyint(1) default '0',
  `center` tinyint(1) default '0',
  `separator1` tinyint(1) default '0',
  `separator2` tinyint(1) default '0',
  `sortOrder` int(4) default '0',
  PRIMARY KEY  (`item`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `options`;
CREATE TABLE `options` (
  `optionID` tinyint(4) NOT NULL auto_increment,
  `optionItemID` tinyint(4) NOT NULL default '0',
  `optionDesc` text,
  `optionPricePrefix` tinytext,
  `optionPrice` tinytext,
  `optionSortOrder` tinyint(3) default '0',
  PRIMARY KEY  (`optionID`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` tinyint(1) NOT NULL auto_increment,
  `homeURL` varchar(255) default NULL,
  `headerHTML` text,
  `footerHTML` text,
  `printableMenu` varchar(255) default NULL,
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pageTitle` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;
INSERT INTO `settings` (`id`, `homeURL`, `headerHTML`, `footerHTML`, `printableMenu`, `username`, `password`, `email`, `pageTitle`) VALUES (1, NULL, NULL, NULL, NULL, 'admin', 'pass', '', 'MENUDO');